Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 5121 |
| Missing cells | 12098 |
| Missing cells (%) | 15.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 600.2 KiB |
| Average record size in memory | 120.0 B |
Variable types
| Text | 10 |
|---|---|
| Categorical | 5 |
country_code is highly overall correlated with country_name and 2 other fields | High correlation |
country_name is highly overall correlated with country_code and 2 other fields | High correlation |
iso_3166_1_alpha_2 is highly overall correlated with country_code and 2 other fields | High correlation |
iso_3166_1_alpha_3 is highly overall correlated with country_code and 2 other fields | High correlation |
aggregation_level is highly imbalanced (97.6%) | Imbalance |
datacommons_id has 1792 (35.0%) missing values | Missing |
locality_code has 5109 (99.8%) missing values | Missing |
locality_name has 5109 (99.8%) missing values | Missing |
location_key has unique values | Unique |
Reproduction
| Analysis started | 2023-09-08 00:00:54.886678 |
|---|---|
| Analysis finished | 2023-09-08 00:00:56.112108 |
| Duration | 1.23 second |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
location_key
Text
UNIQUE
| Distinct | 5121 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 40.1 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 10.943175 |
| Min length | 8 |
Characters and Unicode
| Total characters | 56040 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 5121 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | DE_BB_12051 |
|---|---|
| 2nd row | DE_BB_12052 |
| 3rd row | DE_BB_12053 |
| 4th row | DE_BB_12054 |
| 5th row | DE_BB_12060 |
| Value | Count | Frequency (%) |
| de_bb_12051 | 1 | < 0.1% |
| de_bb_12052 | 1 | < 0.1% |
| de_bb_12053 | 1 | < 0.1% |
| de_bb_12054 | 1 | < 0.1% |
| de_bb_12060 | 1 | < 0.1% |
| de_bb_12061 | 1 | < 0.1% |
| de_bb_12062 | 1 | < 0.1% |
| de_bb_12063 | 1 | < 0.1% |
| de_bb_12064 | 1 | < 0.1% |
| de_be_11002 | 1 | < 0.1% |
| Other values (5111) | 5111 |
Most occurring characters
| Value | Count | Frequency (%) |
| _ | 10242 | |
| S | 4969 | 8.9% |
| 0 | 4832 | 8.6% |
| 1 | 4529 | 8.1% |
| U | 3263 | 5.8% |
| 2 | 2821 | 5.0% |
| 3 | 2605 | 4.6% |
| 5 | 2302 | 4.1% |
| 7 | 2052 | 3.7% |
| E | 1953 | 3.5% |
| Other values (27) | 16472 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 25278 | |
| Uppercase Letter | 20520 | |
| Connector Punctuation | 10242 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 4969 | |
| U | 3263 | |
| E | 1953 | 9.5% |
| T | 1695 | 8.3% |
| C | 1477 | 7.2% |
| N | 882 | 4.3% |
| A | 840 | 4.1% |
| D | 807 | 3.9% |
| M | 733 | 3.6% |
| I | 663 | 3.2% |
| Other values (16) | 3238 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4832 | |
| 1 | 4529 | |
| 2 | 2821 | |
| 3 | 2605 | |
| 5 | 2302 | |
| 7 | 2052 | |
| 4 | 1767 | 7.0% |
| 8 | 1715 | 6.8% |
| 9 | 1582 | 6.3% |
| 6 | 1073 | 4.2% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 10242 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 35520 | |
| Latin | 20520 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 4969 | |
| U | 3263 | |
| E | 1953 | 9.5% |
| T | 1695 | 8.3% |
| C | 1477 | 7.2% |
| N | 882 | 4.3% |
| A | 840 | 4.1% |
| D | 807 | 3.9% |
| M | 733 | 3.6% |
| I | 663 | 3.2% |
| Other values (16) | 3238 |
Common
| Value | Count | Frequency (%) |
| _ | 10242 | |
| 0 | 4832 | |
| 1 | 4529 | |
| 2 | 2821 | 7.9% |
| 3 | 2605 | 7.3% |
| 5 | 2302 | 6.5% |
| 7 | 2052 | 5.8% |
| 4 | 1767 | 5.0% |
| 8 | 1715 | 4.8% |
| 9 | 1582 | 4.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 56040 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| _ | 10242 | |
| S | 4969 | 8.9% |
| 0 | 4832 | 8.6% |
| 1 | 4529 | 8.1% |
| U | 3263 | 5.8% |
| 2 | 2821 | 5.0% |
| 3 | 2605 | 4.6% |
| 5 | 2302 | 4.1% |
| 7 | 2052 | 3.7% |
| E | 1953 | 3.5% |
| Other values (27) | 16472 |
place_id
Text
| Distinct | 5079 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 41 |
| Missing (%) | 0.8% |
| Memory size | 40.1 KiB |
Length
| Max length | 27 |
|---|---|
| Median length | 27 |
| Mean length | 27 |
| Min length | 27 |
Characters and Unicode
| Total characters | 137160 |
|---|---|
| Distinct characters | 64 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 5078 ? |
|---|---|
| Unique (%) | > 99.9% |
Sample
| 1st row | ChIJN8I30-XAqEcRhUxEEOyL_kg |
|---|---|
| 2nd row | ChIJX0qVWUJ0CEcROq1_4LUv1FA |
| 3rd row | ChIJb_u1AiqYB0cRwDteW0YgIQQ |
| 4th row | ChIJt9Y6hM31qEcRm-yqC5j4ZcU |
| 5th row | ChIJuRSkBF66qUcRCDglm8hflWE |
| Value | Count | Frequency (%) |
| chij5tcocraypbircmzhtz37seq | 2 | < 0.1% |
| chiji_gahcomqucrbukua-romqo | 1 | < 0.1% |
| chijt9y6hm31qecrm-yqc5j4zcu | 1 | < 0.1% |
| chijurskbf66qucrcdglm8hflwe | 1 | < 0.1% |
| chijtzgngtz3b0cryli-iutzpcs | 1 | < 0.1% |
| chijmxhwdojyp0crvhczxc3nkw4 | 1 | < 0.1% |
| chij74pplnxdqecr1pr8inhoolm | 1 | < 0.1% |
| chijzwlb3jjwqucrxb06n0k3wgk | 1 | < 0.1% |
| chijss8a9zdoqecr5htxfi0sg-a | 1 | < 0.1% |
| chijtuu0ylenb0cr3_w_qw_ineq | 1 | < 0.1% |
| Other values (5069) | 5069 |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 8734 | 6.4% |
| R | 6860 | 5.0% |
| h | 6779 | 4.9% |
| C | 6482 | 4.7% |
| J | 6427 | 4.7% |
| c | 3085 | 2.2% |
| Y | 2937 | 2.1% |
| g | 2900 | 2.1% |
| 4 | 2588 | 1.9% |
| Q | 2588 | 1.9% |
| Other values (54) | 87780 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 65929 | |
| Lowercase Letter | 50561 | |
| Decimal Number | 17661 | 12.9% |
| Connector Punctuation | 1512 | 1.1% |
| Dash Punctuation | 1497 | 1.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 8734 | 13.2% |
| R | 6860 | 10.4% |
| C | 6482 | 9.8% |
| J | 6427 | 9.7% |
| Y | 2937 | 4.5% |
| Q | 2588 | 3.9% |
| A | 2319 | 3.5% |
| U | 2100 | 3.2% |
| M | 1986 | 3.0% |
| B | 1768 | 2.7% |
| Other values (16) | 23728 |
Lowercase Letter
| Value | Count | Frequency (%) |
| h | 6779 | 13.4% |
| c | 3085 | 6.1% |
| g | 2900 | 5.7% |
| o | 2567 | 5.1% |
| w | 2253 | 4.5% |
| k | 2220 | 4.4% |
| p | 1920 | 3.8% |
| s | 1816 | 3.6% |
| u | 1680 | 3.3% |
| x | 1679 | 3.3% |
| Other values (16) | 23662 |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 2588 | |
| 0 | 2223 | |
| 8 | 1869 | |
| 6 | 1662 | |
| 1 | 1579 | |
| 7 | 1568 | |
| 3 | 1551 | |
| 9 | 1550 | |
| 2 | 1548 | |
| 5 | 1523 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1512 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1497 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 116490 | |
| Common | 20670 | 15.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 8734 | 7.5% |
| R | 6860 | 5.9% |
| h | 6779 | 5.8% |
| C | 6482 | 5.6% |
| J | 6427 | 5.5% |
| c | 3085 | 2.6% |
| Y | 2937 | 2.5% |
| g | 2900 | 2.5% |
| Q | 2588 | 2.2% |
| o | 2567 | 2.2% |
| Other values (42) | 67131 |
Common
| Value | Count | Frequency (%) |
| 4 | 2588 | |
| 0 | 2223 | |
| 8 | 1869 | |
| 6 | 1662 | |
| 1 | 1579 | |
| 7 | 1568 | |
| 3 | 1551 | |
| 9 | 1550 | |
| 2 | 1548 | |
| 5 | 1523 | |
| Other values (2) | 3009 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 137160 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| I | 8734 | 6.4% |
| R | 6860 | 5.0% |
| h | 6779 | 4.9% |
| C | 6482 | 4.7% |
| J | 6427 | 4.7% |
| c | 3085 | 2.2% |
| Y | 2937 | 2.1% |
| g | 2900 | 2.1% |
| 4 | 2588 | 1.9% |
| Q | 2588 | 1.9% |
| Other values (54) | 87780 |
wikidata_id
Text
| Distinct | 5097 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 23 |
| Missing (%) | 0.4% |
| Memory size | 40.1 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.766379 |
| Min length | 3 |
Characters and Unicode
| Total characters | 34495 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 5096 ? |
|---|---|
| Unique (%) | > 99.9% |
Sample
| 1st row | Q3931 |
|---|---|
| 2nd row | Q3214 |
| 3rd row | Q4024 |
| 4th row | Q1711 |
| 5th row | Q6115 |
| Value | Count | Frequency (%) |
| q1492 | 2 | < 0.1% |
| q6178 | 1 | < 0.1% |
| q6115 | 1 | < 0.1% |
| q6173 | 1 | < 0.1% |
| q6152 | 1 | < 0.1% |
| q6139 | 1 | < 0.1% |
| q6181 | 1 | < 0.1% |
| q158893 | 1 | < 0.1% |
| q6119 | 1 | < 0.1% |
| q6125 | 1 | < 0.1% |
| Other values (5087) | 5087 |
Most occurring characters
| Value | Count | Frequency (%) |
| Q | 5098 | |
| 1 | 4325 | |
| 4 | 3637 | |
| 5 | 3184 | |
| 9 | 2863 | |
| 8 | 2775 | |
| 6 | 2745 | |
| 0 | 2691 | |
| 2 | 2495 | |
| 3 | 2371 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 29397 | |
| Uppercase Letter | 5098 | 14.8% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 4325 | |
| 4 | 3637 | |
| 5 | 3184 | |
| 9 | 2863 | |
| 8 | 2775 | |
| 6 | 2745 | |
| 0 | 2691 | |
| 2 | 2495 | |
| 3 | 2371 | |
| 7 | 2311 |
Uppercase Letter
| Value | Count | Frequency (%) |
| Q | 5098 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 29397 | |
| Latin | 5098 | 14.8% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 4325 | |
| 4 | 3637 | |
| 5 | 3184 | |
| 9 | 2863 | |
| 8 | 2775 | |
| 6 | 2745 | |
| 0 | 2691 | |
| 2 | 2495 | |
| 3 | 2371 | |
| 7 | 2311 |
Latin
| Value | Count | Frequency (%) |
| Q | 5098 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 34495 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| Q | 5098 | |
| 1 | 4325 | |
| 4 | 3637 | |
| 5 | 3184 | |
| 9 | 2863 | |
| 8 | 2775 | |
| 6 | 2745 | |
| 0 | 2691 | |
| 2 | 2495 | |
| 3 | 2371 |
datacommons_id
Text
MISSING
| Distinct | 3329 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1792 |
| Missing (%) | 35.0% |
| Memory size | 40.1 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 10.93872 |
| Min length | 9 |
Characters and Unicode
| Total characters | 36415 |
|---|---|
| Distinct characters | 40 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3329 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | iso/IT-AL |
|---|---|
| 2nd row | iso/IT-AT |
| 3rd row | iso/IT-BI |
| 4th row | iso/IT-CN |
| 5th row | iso/IT-NO |
| Value | Count | Frequency (%) |
| geoid/44003 | 1 | < 0.1% |
| geoid/28083 | 1 | < 0.1% |
| iso/it-cr | 1 | < 0.1% |
| iso/it-at | 1 | < 0.1% |
| iso/it-bi | 1 | < 0.1% |
| iso/it-cn | 1 | < 0.1% |
| iso/it-no | 1 | < 0.1% |
| iso/it-to | 1 | < 0.1% |
| iso/it-vb | 1 | < 0.1% |
| iso/it-vc | 1 | < 0.1% |
| Other values (3319) | 3319 |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 3336 | |
| o | 3329 | |
| / | 3329 | |
| g | 3226 | |
| d | 3226 | |
| e | 3226 | |
| 1 | 3049 | |
| 0 | 3044 | |
| 3 | 1802 | 4.9% |
| 2 | 1572 | 4.3% |
| Other values (30) | 7276 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 16132 | |
| Lowercase Letter | 13216 | |
| Uppercase Letter | 3635 | 10.0% |
| Other Punctuation | 3329 | 9.1% |
| Dash Punctuation | 103 | 0.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 3336 | |
| T | 117 | 3.2% |
| R | 19 | 0.5% |
| C | 17 | 0.5% |
| P | 16 | 0.4% |
| A | 15 | 0.4% |
| S | 14 | 0.4% |
| V | 13 | 0.4% |
| B | 12 | 0.3% |
| O | 11 | 0.3% |
| Other values (12) | 65 | 1.8% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 3049 | |
| 0 | 3044 | |
| 3 | 1802 | |
| 2 | 1572 | |
| 5 | 1526 | |
| 7 | 1361 | |
| 9 | 1175 | 7.3% |
| 4 | 1162 | 7.2% |
| 8 | 808 | 5.0% |
| 6 | 633 | 3.9% |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 3329 | |
| g | 3226 | |
| d | 3226 | |
| e | 3226 | |
| i | 106 | 0.8% |
| s | 103 | 0.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 3329 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 103 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 19564 | |
| Latin | 16851 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 3336 | |
| o | 3329 | |
| g | 3226 | |
| d | 3226 | |
| e | 3226 | |
| T | 117 | 0.7% |
| i | 106 | 0.6% |
| s | 103 | 0.6% |
| R | 19 | 0.1% |
| C | 17 | 0.1% |
| Other values (18) | 146 | 0.9% |
Common
| Value | Count | Frequency (%) |
| / | 3329 | |
| 1 | 3049 | |
| 0 | 3044 | |
| 3 | 1802 | |
| 2 | 1572 | |
| 5 | 1526 | |
| 7 | 1361 | |
| 9 | 1175 | 6.0% |
| 4 | 1162 | 5.9% |
| 8 | 808 | 4.1% |
| Other values (2) | 736 | 3.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 36415 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| I | 3336 | |
| o | 3329 | |
| / | 3329 | |
| g | 3226 | |
| d | 3226 | |
| e | 3226 | |
| 1 | 3049 | |
| 0 | 3044 | |
| 3 | 1802 | 4.9% |
| 2 | 1572 | 4.3% |
| Other values (30) | 7276 |
country_code
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 40.1 KiB |
| US | |
|---|---|
| ES | |
| DE | |
| IT | 103 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 10242 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DE |
|---|---|
| 2nd row | DE |
| 3rd row | DE |
| 4th row | DE |
| 5th row | DE |
Common Values
| Value | Count | Frequency (%) |
| US | 3228 | |
| ES | 1378 | |
| DE | 412 | 8.0% |
| IT | 103 | 2.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| us | 3228 | |
| es | 1378 | |
| de | 412 | 8.0% |
| it | 103 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 4606 | |
| U | 3228 | |
| E | 1790 | 17.5% |
| D | 412 | 4.0% |
| I | 103 | 1.0% |
| T | 103 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 10242 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 4606 | |
| U | 3228 | |
| E | 1790 | 17.5% |
| D | 412 | 4.0% |
| I | 103 | 1.0% |
| T | 103 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 10242 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 4606 | |
| U | 3228 | |
| E | 1790 | 17.5% |
| D | 412 | 4.0% |
| I | 103 | 1.0% |
| T | 103 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10242 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 4606 | |
| U | 3228 | |
| E | 1790 | 17.5% |
| D | 412 | 4.0% |
| I | 103 | 1.0% |
| T | 103 | 1.0% |
country_name
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 40.1 KiB |
| United States of America | |
|---|---|
| Spain | |
| Germany | |
| Italy | 103 |
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 17.137473 |
| Min length | 5 |
Characters and Unicode
| Total characters | 87761 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Germany |
|---|---|
| 2nd row | Germany |
| 3rd row | Germany |
| 4th row | Germany |
| 5th row | Germany |
Common Values
| Value | Count | Frequency (%) |
| United States of America | 3228 | |
| Spain | 1378 | |
| Germany | 412 | 8.0% |
| Italy | 103 | 2.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| united | 3228 | |
| states | 3228 | |
| of | 3228 | |
| america | 3228 | |
| spain | 1378 | |
| germany | 412 | 2.8% |
| italy | 103 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 10096 | |
| t | 9787 | |
| 9684 | ||
| a | 8349 | 9.5% |
| i | 7834 | 8.9% |
| n | 5018 | 5.7% |
| S | 4606 | 5.2% |
| r | 3640 | 4.1% |
| m | 3640 | 4.1% |
| U | 3228 | 3.7% |
| Other values (11) | 21879 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 66500 | |
| Uppercase Letter | 11577 | 13.2% |
| Space Separator | 9684 | 11.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 10096 | |
| t | 9787 | |
| a | 8349 | |
| i | 7834 | |
| n | 5018 | |
| r | 3640 | 5.5% |
| m | 3640 | 5.5% |
| c | 3228 | 4.9% |
| o | 3228 | 4.9% |
| f | 3228 | 4.9% |
| Other values (5) | 8452 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 4606 | |
| U | 3228 | |
| A | 3228 | |
| G | 412 | 3.6% |
| I | 103 | 0.9% |
Space Separator
| Value | Count | Frequency (%) |
| 9684 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 78077 | |
| Common | 9684 | 11.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 10096 | |
| t | 9787 | |
| a | 8349 | |
| i | 7834 | |
| n | 5018 | 6.4% |
| S | 4606 | 5.9% |
| r | 3640 | 4.7% |
| m | 3640 | 4.7% |
| U | 3228 | 4.1% |
| A | 3228 | 4.1% |
| Other values (10) | 18651 |
Common
| Value | Count | Frequency (%) |
| 9684 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 87761 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 10096 | |
| t | 9787 | |
| 9684 | ||
| a | 8349 | 9.5% |
| i | 7834 | 8.9% |
| n | 5018 | 5.7% |
| S | 4606 | 5.2% |
| r | 3640 | 4.1% |
| m | 3640 | 4.1% |
| U | 3228 | 3.7% |
| Other values (11) | 21879 |
subregion1_code
Text
| Distinct | 89 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 40.1 KiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 10242 |
|---|---|
| Distinct characters | 33 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | BB |
|---|---|
| 2nd row | BB |
| 3rd row | BB |
| 4th row | BB |
| 5th row | BB |
| Value | Count | Frequency (%) |
| ct | 1091 | |
| tx | 254 | 5.0% |
| md | 224 | 4.4% |
| ga | 160 | 3.1% |
| va | 133 | 2.6% |
| ky | 120 | 2.3% |
| mo | 115 | 2.2% |
| ks | 105 | 2.1% |
| il | 102 | 2.0% |
| nc | 100 | 2.0% |
| Other values (79) | 2717 |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 1576 | |
| C | 1456 | |
| N | 870 | 8.5% |
| A | 821 | 8.0% |
| M | 720 | 7.0% |
| I | 550 | 5.4% |
| D | 391 | 3.8% |
| O | 380 | 3.7% |
| S | 347 | 3.4% |
| K | 331 | 3.2% |
| Other values (23) | 2800 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 10036 | |
| Decimal Number | 206 | 2.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 1576 | |
| C | 1456 | |
| N | 870 | 8.7% |
| A | 821 | 8.2% |
| M | 720 | 7.2% |
| I | 550 | 5.5% |
| D | 391 | 3.9% |
| O | 380 | 3.8% |
| S | 347 | 3.5% |
| K | 331 | 3.3% |
| Other values (15) | 2594 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 52 | |
| 5 | 50 | |
| 7 | 26 | |
| 8 | 24 | |
| 4 | 20 | 9.7% |
| 6 | 15 | 7.3% |
| 3 | 11 | 5.3% |
| 1 | 8 | 3.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 10036 | |
| Common | 206 | 2.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 1576 | |
| C | 1456 | |
| N | 870 | 8.7% |
| A | 821 | 8.2% |
| M | 720 | 7.2% |
| I | 550 | 5.5% |
| D | 391 | 3.9% |
| O | 380 | 3.8% |
| S | 347 | 3.5% |
| K | 331 | 3.3% |
| Other values (15) | 2594 |
Common
| Value | Count | Frequency (%) |
| 2 | 52 | |
| 5 | 50 | |
| 7 | 26 | |
| 8 | 24 | |
| 4 | 20 | 9.7% |
| 6 | 15 | 7.3% |
| 3 | 11 | 5.3% |
| 1 | 8 | 3.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10242 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 1576 | |
| C | 1456 | |
| N | 870 | 8.5% |
| A | 821 | 8.0% |
| M | 720 | 7.0% |
| I | 550 | 5.4% |
| D | 391 | 3.8% |
| O | 380 | 3.7% |
| S | 347 | 3.4% |
| K | 331 | 3.2% |
| Other values (23) | 2800 |
subregion1_name
Text
| Distinct | 91 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 40.1 KiB |
Length
| Max length | 24 |
|---|---|
| Median length | 22 |
| Mean length | 9.0244093 |
| Min length | 4 |
Characters and Unicode
| Total characters | 46214 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Brandenburg |
|---|---|
| 2nd row | Brandenburg |
| 3rd row | Brandenburg |
| 4th row | Brandenburg |
| 5th row | Brandenburg |
| Value | Count | Frequency (%) |
| cataluña | 1083 | 17.3% |
| texas | 254 | 4.1% |
| north | 206 | 3.3% |
| comunidad | 200 | 3.2% |
| de | 200 | 3.2% |
| madrid | 200 | 3.2% |
| virginia | 188 | 3.0% |
| georgia | 160 | 2.6% |
| carolina | 146 | 2.3% |
| new | 127 | 2.0% |
| Other values (93) | 3497 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 8342 | |
| i | 3799 | 8.2% |
| n | 2929 | 6.3% |
| o | 2656 | 5.7% |
| s | 2579 | 5.6% |
| e | 2356 | 5.1% |
| t | 2305 | 5.0% |
| l | 2232 | 4.8% |
| r | 2116 | 4.6% |
| u | 1877 | 4.1% |
| Other values (41) | 15023 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 38656 | |
| Uppercase Letter | 6239 | 13.5% |
| Space Separator | 1140 | 2.5% |
| Dash Punctuation | 179 | 0.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 8342 | |
| i | 3799 | |
| n | 2929 | 7.6% |
| o | 2656 | 6.9% |
| s | 2579 | 6.7% |
| e | 2356 | 6.1% |
| t | 2305 | 6.0% |
| l | 2232 | 5.8% |
| r | 2116 | 5.5% |
| u | 1877 | 4.9% |
| Other values (16) | 7465 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 1665 | |
| M | 727 | |
| N | 445 | 7.1% |
| I | 442 | 7.1% |
| T | 382 | 6.1% |
| W | 286 | 4.6% |
| K | 225 | 3.6% |
| V | 224 | 3.6% |
| S | 219 | 3.5% |
| A | 210 | 3.4% |
| Other values (13) | 1414 |
Space Separator
| Value | Count | Frequency (%) |
| 1140 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 179 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 44895 | |
| Common | 1319 | 2.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 8342 | |
| i | 3799 | 8.5% |
| n | 2929 | 6.5% |
| o | 2656 | 5.9% |
| s | 2579 | 5.7% |
| e | 2356 | 5.2% |
| t | 2305 | 5.1% |
| l | 2232 | 5.0% |
| r | 2116 | 4.7% |
| u | 1877 | 4.2% |
| Other values (39) | 13704 |
Common
| Value | Count | Frequency (%) |
| 1140 | ||
| - | 179 | 13.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 45087 | |
| None | 1127 | 2.4% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 8342 | |
| i | 3799 | 8.4% |
| n | 2929 | 6.5% |
| o | 2656 | 5.9% |
| s | 2579 | 5.7% |
| e | 2356 | 5.2% |
| t | 2305 | 5.1% |
| l | 2232 | 5.0% |
| r | 2116 | 4.7% |
| u | 1877 | 4.2% |
| Other values (39) | 13896 |
None
| Value | Count | Frequency (%) |
| ñ | 1083 | |
| ü | 44 | 3.9% |
subregion2_code
Text
| Distinct | 4680 |
|---|---|
| Distinct (%) | 91.6% |
| Missing | 12 |
| Missing (%) | 0.2% |
| Memory size | 40.1 KiB |
Length
| Max length | 7 |
|---|---|
| Median length | 5 |
| Mean length | 4.9477393 |
| Min length | 2 |
Characters and Unicode
| Total characters | 25278 |
|---|---|
| Distinct characters | 32 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4266 ? |
|---|---|
| Unique (%) | 83.5% |
Sample
| 1st row | 12051 |
|---|---|
| 2nd row | 12052 |
| 3rd row | 12053 |
| 4th row | 12054 |
| 5th row | 12060 |
| Value | Count | Frequency (%) |
| 12051 | 3 | 0.1% |
| 12071 | 3 | 0.1% |
| 12067 | 3 | 0.1% |
| 12061 | 3 | 0.1% |
| 12053 | 3 | 0.1% |
| 12063 | 3 | 0.1% |
| 08125 | 3 | 0.1% |
| 12069 | 3 | 0.1% |
| 12065 | 3 | 0.1% |
| 12073 | 3 | 0.1% |
| Other values (4670) | 5079 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4832 | |
| 1 | 4521 | |
| 2 | 2769 | |
| 3 | 2594 | |
| 5 | 2252 | |
| 7 | 2026 | |
| 4 | 1747 | 6.9% |
| 8 | 1691 | 6.7% |
| 9 | 1582 | 6.3% |
| 6 | 1058 | 4.2% |
| Other values (22) | 206 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 25072 | |
| Uppercase Letter | 206 | 0.8% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 19 | 9.2% |
| C | 17 | 8.3% |
| P | 16 | 7.8% |
| A | 15 | 7.3% |
| T | 14 | 6.8% |
| S | 14 | 6.8% |
| V | 13 | 6.3% |
| B | 12 | 5.8% |
| O | 11 | 5.3% |
| M | 11 | 5.3% |
| Other values (12) | 64 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4832 | |
| 1 | 4521 | |
| 2 | 2769 | |
| 3 | 2594 | |
| 5 | 2252 | |
| 7 | 2026 | |
| 4 | 1747 | 7.0% |
| 8 | 1691 | 6.7% |
| 9 | 1582 | 6.3% |
| 6 | 1058 | 4.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 25072 | |
| Latin | 206 | 0.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 19 | 9.2% |
| C | 17 | 8.3% |
| P | 16 | 7.8% |
| A | 15 | 7.3% |
| T | 14 | 6.8% |
| S | 14 | 6.8% |
| V | 13 | 6.3% |
| B | 12 | 5.8% |
| O | 11 | 5.3% |
| M | 11 | 5.3% |
| Other values (12) | 64 |
Common
| Value | Count | Frequency (%) |
| 0 | 4832 | |
| 1 | 4521 | |
| 2 | 2769 | |
| 3 | 2594 | |
| 5 | 2252 | |
| 7 | 2026 | |
| 4 | 1747 | 7.0% |
| 8 | 1691 | 6.7% |
| 9 | 1582 | 6.3% |
| 6 | 1058 | 4.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 25278 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4832 | |
| 1 | 4521 | |
| 2 | 2769 | |
| 3 | 2594 | |
| 5 | 2252 | |
| 7 | 2026 | |
| 4 | 1747 | 6.9% |
| 8 | 1691 | 6.7% |
| 9 | 1582 | 6.3% |
| 6 | 1058 | 4.2% |
| Other values (22) | 206 | 0.8% |
subregion2_name
Text
| Distinct | 3834 |
|---|---|
| Distinct (%) | 75.0% |
| Missing | 12 |
| Missing (%) | 0.2% |
| Memory size | 40.1 KiB |
Length
| Max length | 44 |
|---|---|
| Median length | 33 |
| Mean length | 13.225289 |
| Min length | 3 |
Characters and Unicode
| Total characters | 67568 |
|---|---|
| Distinct characters | 81 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3401 ? |
|---|---|
| Unique (%) | 66.6% |
Sample
| 1st row | Brandenburg an der Havel |
|---|---|
| 2nd row | Cottbus |
| 3rd row | Frankfurt an der Oder |
| 4th row | Potsdam |
| 5th row | Barnim |
| Value | Count | Frequency (%) |
| county | 3008 | |
| de | 334 | 3.3% |
| la | 140 | 1.4% |
| sant | 92 | 0.9% |
| municipio | 78 | 0.8% |
| del | 77 | 0.8% |
| parish | 64 | 0.6% |
| el | 50 | 0.5% |
| santa | 42 | 0.4% |
| san | 40 | 0.4% |
| Other values (3934) | 6078 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 6219 | 9.2% |
| o | 5846 | 8.7% |
| a | 5025 | 7.4% |
| 4894 | 7.2% | |
| t | 4838 | 7.2% |
| e | 4496 | 6.7% |
| u | 4228 | 6.3% |
| C | 3691 | 5.5% |
| y | 3444 | 5.1% |
| r | 3194 | 4.7% |
| Other values (71) | 21693 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 52774 | |
| Uppercase Letter | 9630 | 14.3% |
| Space Separator | 4894 | 7.2% |
| Dash Punctuation | 141 | 0.2% |
| Other Punctuation | 117 | 0.2% |
| Close Punctuation | 5 | < 0.1% |
| Open Punctuation | 5 | < 0.1% |
| Final Punctuation | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 6219 | |
| o | 5846 | |
| a | 5025 | |
| t | 4838 | |
| e | 4496 | |
| u | 4228 | |
| y | 3444 | 6.5% |
| r | 3194 | 6.1% |
| l | 3065 | 5.8% |
| i | 2541 | 4.8% |
| Other values (32) | 9878 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 3691 | |
| S | 639 | 6.6% |
| M | 636 | 6.6% |
| L | 494 | 5.1% |
| P | 471 | 4.9% |
| B | 453 | 4.7% |
| A | 345 | 3.6% |
| G | 272 | 2.8% |
| R | 265 | 2.8% |
| H | 264 | 2.7% |
| Other values (20) | 2100 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 78 | |
| . | 28 | 23.9% |
| , | 6 | 5.1% |
| / | 5 | 4.3% |
Space Separator
| Value | Count | Frequency (%) |
| 4894 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 141 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 5 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 5 |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 62404 | |
| Common | 5164 | 7.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 6219 | 10.0% |
| o | 5846 | 9.4% |
| a | 5025 | 8.1% |
| t | 4838 | 7.8% |
| e | 4496 | 7.2% |
| u | 4228 | 6.8% |
| C | 3691 | 5.9% |
| y | 3444 | 5.5% |
| r | 3194 | 5.1% |
| l | 3065 | 4.9% |
| Other values (62) | 18358 |
Common
| Value | Count | Frequency (%) |
| 4894 | ||
| - | 141 | 2.7% |
| ' | 78 | 1.5% |
| . | 28 | 0.5% |
| , | 6 | 0.1% |
| ) | 5 | 0.1% |
| ( | 5 | 0.1% |
| / | 5 | 0.1% |
| ’ | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 67068 | |
| None | 498 | 0.7% |
| Punctuation | 2 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 6219 | 9.3% |
| o | 5846 | 8.7% |
| a | 5025 | 7.5% |
| 4894 | 7.3% | |
| t | 4838 | 7.2% |
| e | 4496 | 6.7% |
| u | 4228 | 6.3% |
| C | 3691 | 5.5% |
| y | 3444 | 5.1% |
| r | 3194 | 4.8% |
| Other values (50) | 21193 |
None
| Value | Count | Frequency (%) |
| Ã | 109 | |
| ó | 74 | |
| Ã | 73 | |
| è | 42 | 8.4% |
| ü | 39 | 7.8% |
| ç | 27 | 5.4% |
| é | 25 | 5.0% |
| ö | 18 | 3.6% |
| ñ | 18 | 3.6% |
| á | 17 | 3.4% |
| Other values (10) | 56 |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 2 |
locality_code
Text
MISSING
| Distinct | 12 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 5109 |
| Missing (%) | 99.8% |
| Memory size | 40.1 KiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 36 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | ACE |
|---|---|
| 2nd row | FUE |
| 3rd row | GMZ |
| 4th row | LPA |
| 5th row | SPC |
| Value | Count | Frequency (%) |
| ace | 1 | |
| fue | 1 | |
| gmz | 1 | |
| lpa | 1 | |
| spc | 1 | |
| tfn | 1 | |
| vde | 1 | |
| bcn | 1 | |
| mad | 1 | |
| sfo | 1 | |
| Other values (2) | 2 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 4 | |
| C | 4 | |
| E | 3 | 8.3% |
| F | 3 | 8.3% |
| N | 3 | 8.3% |
| D | 2 | 5.6% |
| T | 2 | 5.6% |
| S | 2 | 5.6% |
| P | 2 | 5.6% |
| L | 2 | 5.6% |
| Other values (8) | 9 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 36 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 4 | |
| C | 4 | |
| E | 3 | 8.3% |
| F | 3 | 8.3% |
| N | 3 | 8.3% |
| D | 2 | 5.6% |
| T | 2 | 5.6% |
| S | 2 | 5.6% |
| P | 2 | 5.6% |
| L | 2 | 5.6% |
| Other values (8) | 9 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 36 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 4 | |
| C | 4 | |
| E | 3 | 8.3% |
| F | 3 | 8.3% |
| N | 3 | 8.3% |
| D | 2 | 5.6% |
| T | 2 | 5.6% |
| S | 2 | 5.6% |
| P | 2 | 5.6% |
| L | 2 | 5.6% |
| Other values (8) | 9 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 36 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 4 | |
| C | 4 | |
| E | 3 | 8.3% |
| F | 3 | 8.3% |
| N | 3 | 8.3% |
| D | 2 | 5.6% |
| T | 2 | 5.6% |
| S | 2 | 5.6% |
| P | 2 | 5.6% |
| L | 2 | 5.6% |
| Other values (8) | 9 |
locality_name
Text
MISSING
| Distinct | 12 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 5109 |
| Missing (%) | 99.8% |
| Memory size | 40.1 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 12 |
| Mean length | 9.6666667 |
| Min length | 6 |
Characters and Unicode
| Total characters | 116 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Lanzarote |
|---|---|
| 2nd row | Fuerteventura |
| 3rd row | La Gomera |
| 4th row | Gran Canaria |
| 5th row | La Palma |
| Value | Count | Frequency (%) |
| la | 2 | 10.5% |
| lanzarote | 1 | 5.3% |
| barcelona | 1 | 5.3% |
| york | 1 | 5.3% |
| new | 1 | 5.3% |
| atlanta | 1 | 5.3% |
| francisco | 1 | 5.3% |
| san | 1 | 5.3% |
| madrid | 1 | 5.3% |
| hierro | 1 | 5.3% |
| Other values (8) | 8 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 19 | |
| r | 13 | |
| e | 11 | 9.5% |
| n | 9 | 7.8% |
| 7 | 6.0% | |
| o | 6 | 5.2% |
| t | 6 | 5.2% |
| i | 6 | 5.2% |
| l | 4 | 3.4% |
| c | 3 | 2.6% |
| Other values (24) | 32 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 90 | |
| Uppercase Letter | 19 | 16.4% |
| Space Separator | 7 | 6.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 19 | |
| r | 13 | |
| e | 11 | |
| n | 9 | |
| o | 6 | 6.7% |
| t | 6 | 6.7% |
| i | 6 | 6.7% |
| l | 4 | 4.4% |
| c | 3 | 3.3% |
| d | 2 | 2.2% |
| Other values (9) | 11 |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 3 | |
| C | 2 | |
| F | 2 | |
| G | 2 | |
| Y | 1 | 5.3% |
| N | 1 | 5.3% |
| A | 1 | 5.3% |
| S | 1 | 5.3% |
| B | 1 | 5.3% |
| M | 1 | 5.3% |
| Other values (4) | 4 |
Space Separator
| Value | Count | Frequency (%) |
| 7 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 109 | |
| Common | 7 | 6.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 19 | |
| r | 13 | |
| e | 11 | 10.1% |
| n | 9 | 8.3% |
| o | 6 | 5.5% |
| t | 6 | 5.5% |
| i | 6 | 5.5% |
| l | 4 | 3.7% |
| c | 3 | 2.8% |
| L | 3 | 2.8% |
| Other values (23) | 29 |
Common
| Value | Count | Frequency (%) |
| 7 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 116 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 19 | |
| r | 13 | |
| e | 11 | 9.5% |
| n | 9 | 7.8% |
| 7 | 6.0% | |
| o | 6 | 5.2% |
| t | 6 | 5.2% |
| i | 6 | 5.2% |
| l | 4 | 3.4% |
| c | 3 | 2.6% |
| Other values (24) | 32 |
iso_3166_1_alpha_2
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 40.1 KiB |
| US | |
|---|---|
| ES | |
| DE | |
| IT | 103 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 10242 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DE |
|---|---|
| 2nd row | DE |
| 3rd row | DE |
| 4th row | DE |
| 5th row | DE |
Common Values
| Value | Count | Frequency (%) |
| US | 3228 | |
| ES | 1378 | |
| DE | 412 | 8.0% |
| IT | 103 | 2.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| us | 3228 | |
| es | 1378 | |
| de | 412 | 8.0% |
| it | 103 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 4606 | |
| U | 3228 | |
| E | 1790 | 17.5% |
| D | 412 | 4.0% |
| I | 103 | 1.0% |
| T | 103 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 10242 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 4606 | |
| U | 3228 | |
| E | 1790 | 17.5% |
| D | 412 | 4.0% |
| I | 103 | 1.0% |
| T | 103 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 10242 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 4606 | |
| U | 3228 | |
| E | 1790 | 17.5% |
| D | 412 | 4.0% |
| I | 103 | 1.0% |
| T | 103 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10242 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 4606 | |
| U | 3228 | |
| E | 1790 | 17.5% |
| D | 412 | 4.0% |
| I | 103 | 1.0% |
| T | 103 | 1.0% |
iso_3166_1_alpha_3
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 40.1 KiB |
| USA | |
|---|---|
| ESP | |
| DEU | |
| ITA | 103 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 15363 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DEU |
|---|---|
| 2nd row | DEU |
| 3rd row | DEU |
| 4th row | DEU |
| 5th row | DEU |
Common Values
| Value | Count | Frequency (%) |
| USA | 3228 | |
| ESP | 1378 | |
| DEU | 412 | 8.0% |
| ITA | 103 | 2.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| usa | 3228 | |
| esp | 1378 | |
| deu | 412 | 8.0% |
| ita | 103 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 4606 | |
| U | 3640 | |
| A | 3331 | |
| E | 1790 | 11.7% |
| P | 1378 | 9.0% |
| D | 412 | 2.7% |
| I | 103 | 0.7% |
| T | 103 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 15363 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 4606 | |
| U | 3640 | |
| A | 3331 | |
| E | 1790 | 11.7% |
| P | 1378 | 9.0% |
| D | 412 | 2.7% |
| I | 103 | 0.7% |
| T | 103 | 0.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 15363 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 4606 | |
| U | 3640 | |
| A | 3331 | |
| E | 1790 | 11.7% |
| P | 1378 | 9.0% |
| D | 412 | 2.7% |
| I | 103 | 0.7% |
| T | 103 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15363 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 4606 | |
| U | 3640 | |
| A | 3331 | |
| E | 1790 | 11.7% |
| P | 1378 | 9.0% |
| D | 412 | 2.7% |
| I | 103 | 0.7% |
| T | 103 | 0.7% |
aggregation_level
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 40.1 KiB |
| 2 | |
|---|---|
| 3 | 12 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5121 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 2 |
| 4th row | 2 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 5109 | |
| 3 | 12 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 5109 | |
| 3 | 12 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 5109 | |
| 3 | 12 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5121 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 5109 | |
| 3 | 12 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5121 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 5109 | |
| 3 | 12 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5121 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 5109 | |
| 3 | 12 | 0.2% |
| country_code | country_name | iso_3166_1_alpha_2 | iso_3166_1_alpha_3 | aggregation_level | |
|---|---|---|---|---|---|
| country_code | 1.000 | 1.000 | 1.000 | 1.000 | 0.047 |
| country_name | 1.000 | 1.000 | 1.000 | 1.000 | 0.047 |
| iso_3166_1_alpha_2 | 1.000 | 1.000 | 1.000 | 1.000 | 0.047 |
| iso_3166_1_alpha_3 | 1.000 | 1.000 | 1.000 | 1.000 | 0.047 |
| aggregation_level | 0.047 | 0.047 | 0.047 | 0.047 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| location_key | place_id | wikidata_id | datacommons_id | country_code | country_name | subregion1_code | subregion1_name | subregion2_code | subregion2_name | locality_code | locality_name | iso_3166_1_alpha_2 | iso_3166_1_alpha_3 | aggregation_level | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | DE_BB_12051 | ChIJN8I30-XAqEcRhUxEEOyL_kg | Q3931 | NaN | DE | Germany | BB | Brandenburg | 12051 | Brandenburg an der Havel | NaN | NaN | DE | DEU | 2 |
| 1 | DE_BB_12052 | ChIJX0qVWUJ0CEcROq1_4LUv1FA | Q3214 | NaN | DE | Germany | BB | Brandenburg | 12052 | Cottbus | NaN | NaN | DE | DEU | 2 |
| 2 | DE_BB_12053 | ChIJb_u1AiqYB0cRwDteW0YgIQQ | Q4024 | NaN | DE | Germany | BB | Brandenburg | 12053 | Frankfurt an der Oder | NaN | NaN | DE | DEU | 2 |
| 3 | DE_BB_12054 | ChIJt9Y6hM31qEcRm-yqC5j4ZcU | Q1711 | NaN | DE | Germany | BB | Brandenburg | 12054 | Potsdam | NaN | NaN | DE | DEU | 2 |
| 4 | DE_BB_12060 | ChIJuRSkBF66qUcRCDglm8hflWE | Q6115 | NaN | DE | Germany | BB | Brandenburg | 12060 | Barnim | NaN | NaN | DE | DEU | 2 |
| 5 | DE_BB_12061 | ChIJTZGnGtz3B0cRyLI-iUtZPCs | Q6173 | NaN | DE | Germany | BB | Brandenburg | 12061 | Dahme-Spreewald | NaN | NaN | DE | DEU | 2 |
| 6 | DE_BB_12062 | ChIJmxhwdojyp0cRVHczxC3NkW4 | Q6152 | NaN | DE | Germany | BB | Brandenburg | 12062 | Elbe-Elster | NaN | NaN | DE | DEU | 2 |
| 7 | DE_BB_12063 | ChIJ74pPLNXdqEcR1Pr8iNHoOLM | Q6139 | NaN | DE | Germany | BB | Brandenburg | 12063 | Havelland | NaN | NaN | DE | DEU | 2 |
| 8 | DE_BB_12064 | ChIJzWlb3JjWqUcRxb06n0K3Wgk | Q6181 | NaN | DE | Germany | BB | Brandenburg | 12064 | Märkisch-Oderland | NaN | NaN | DE | DEU | 2 |
| 9 | DE_BB_12065 | ChIJI_gaHCoMqUcRbuKUa-ROMqo | Q6119 | NaN | DE | Germany | BB | Brandenburg | 12065 | Oberhavel | NaN | NaN | DE | DEU | 2 |
| location_key | place_id | wikidata_id | datacommons_id | country_code | country_name | subregion1_code | subregion1_name | subregion2_code | subregion2_name | locality_code | locality_name | iso_3166_1_alpha_2 | iso_3166_1_alpha_3 | aggregation_level | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5111 | US_WY_56027 | ChIJU2Z7QKeaY4cR0e7UZeDrIbs | Q485641 | geoId/56027 | US | United States of America | WY | Wyoming | 56027 | Niobrara County | NaN | NaN | US | USA | 2 |
| 5112 | US_WY_56029 | ChIJHazPIJZeRVMREOKSf3g0edY | Q156385 | geoId/56029 | US | United States of America | WY | Wyoming | 56029 | Park County | NaN | NaN | US | USA | 2 |
| 5113 | US_WY_56031 | ChIJOSq_r9fXZYcROriCFM_N0S4 | Q490512 | geoId/56031 | US | United States of America | WY | Wyoming | 56031 | Platte County | NaN | NaN | US | USA | 2 |
| 5114 | US_WY_56033 | ChIJvzJgFeONNVMRdBzqIEJBwJ0 | Q490522 | geoId/56033 | US | United States of America | WY | Wyoming | 56033 | Sheridan County | NaN | NaN | US | USA | 2 |
| 5115 | US_WY_56035 | ChIJjXutE5u9V4cRjNUtUPgMhns | Q490494 | geoId/56035 | US | United States of America | WY | Wyoming | 56035 | Sublette County | NaN | NaN | US | USA | 2 |
| 5116 | US_WY_56037 | ChIJEVZf4rRTWocRoqATF0f_rnA | Q484194 | geoId/56037 | US | United States of America | WY | Wyoming | 56037 | Sweetwater County | NaN | NaN | US | USA | 2 |
| 5117 | US_WY_56039 | ChIJV3wGpVVrUlMR3m18oGf5rvk | Q488912 | geoId/56039 | US | United States of America | WY | Wyoming | 56039 | Teton County | NaN | NaN | US | USA | 2 |
| 5118 | US_WY_56041 | ChIJR4w4T5CnUYcRvTPRgMmXumM | Q483973 | geoId/56041 | US | United States of America | WY | Wyoming | 56041 | Uinta County | NaN | NaN | US | USA | 2 |
| 5119 | US_WY_56043 | ChIJIXR5_L9BS1MRLvs8KUxeZC8 | Q112846 | geoId/56043 | US | United States of America | WY | Wyoming | 56043 | Washakie County | NaN | NaN | US | USA | 2 |
| 5120 | US_WY_56045 | ChIJd4Rqhed3YocR7ubT5-HgoJg | Q115413 | geoId/56045 | US | United States of America | WY | Wyoming | 56045 | Weston County | NaN | NaN | US | USA | 2 |